note: this file should contain at least sites locations (WGS84) and a numerical value that can be used as classifier (e.g. this file where we should use elevation to classify sites)
Download the on your own computer
Such a window should pop-up.
Choose a suitable name and directory and save this file.
Open Google Fusion Table web page.
Click on create a fusion table > From this computer , search for you .csv file and click next
Check that the table is correctly formatted and click next
You can add a short description of what this table is, contains, … That should be helpful even more if you plan to share this table with collaborators. Click on finish.
Check that your sites location is done according to the longitude and latitudes you gave.
Click Edit > Change columns
Define site_name variable as a Text
And latitude as a Location. Ensure that longitue is recognized as the complementary location (using Two columns location check-box)
Then save the modification and come back to the map. Check that your sites are correctly located on this map.
note: you can play with the way to display the sites via the filter option (e.g. display only locations having a elevation between 300m and 500m)
Click on Share on the top right corner
Click on modifier.. and select Public.
Copy the id of your fusion table in the address bar of your browser (only part after docid=). This is the id you will use to import the fusion table in GEE.
Go to your GEE workspace.
Click on add data > Fusion Table
Paste you Fusion table id and load the table.
Choose a classification variable (e.g. elevation) and set up a classification that suits you.
You can then edit the classification to change names, color, …
You are done !!!
Note: In case you didn’t manage to make it or if you want to compare you results to mine you can use one of the following sections.
Here is the link to the final fusion table Here is the link to the final workspace
Here is the Json version of the final workspace. You can copy this lines and import them in your workspace.
{
"viewport": {
"zoom": 3,
"lat": 66.79190947341799,
"lng": -51.15234375
},
"name": "",
"classmodel": [
{
"name": "< 100m",
"color": "d63000"
},
{
"name": "100m < ele < 200m",
"color": "98ff00"
},
{
"name": "200m < ele < 300m",
"color": "0B4A8B"
},
{
"name": "> 300m",
"color": "ffc82d"
}
],
"polylayers": [
{
"title": "Fusion Table: itex_sites_sample",
"originaltitle": null,
"overlayvisible": true,
"layermode": "advisory-mode",
"datatype": "table",
"mapping": [
[
26,
0
],
[
158,
1
],
[
208,
2
],
[
268,
2
],
[
397,
3
]
],
"id": "1eEaV0k3lg2bQsJc-Pm3oIXNR-I4dfrYfV41cnMHM",
"class_column": "elevation",
"geometry_column": null
}
],
"datalayers": [],
"drawnpoints": [
[],
[],
[],
[]
],
"drawnpolys": [
[],
[],
[],
[]
],
"analysis": null
}